
create table sap_purchase_order (
	code varchar(10) not null,
	date datetime not null,
	line varchar(5) not null,
	plant varchar(4) not null,
	supplier varchar(10) not null,
	currency varchar(3) not null,
	material varchar(8) not null,
	quantity decimal(18,5) not null,
	amount decimal(18,5) not null,
	ionumber varchar(12) null
)
go
